<CFPARAM name="priorityid" default="1">

<cfquery datasource="#application.dsn#" name="getpriorities">
SELECT * FROM priorities
WHERE priorityid=#priorityid#  
</cfquery>

<CFOUTPUT>
<TABLE border="1" cellspacing="1" cellpadding="1" width="50%">

	<TR>
		<TD>sortorder</TD>
		<TD>#getpriorities.sortorder#</TD>
	</TR>
</TABLE>
</CFOUTPUT>
